<%-- 
    Document   : resultjobdetails
    Created on : Apr 23, 2012, 2:30:03 PM
    Author     : project
--%>

<%@page import="java.sql.*"%>
<%@page import="jobportal.Dbconn" %>
<%@include file="header.jsp" %>
<%try {
                Connection con = Dbconn.getConn();
                String jobid = "";
                jobid = request.getParameter("jobid");
                Statement st = con.createStatement();
                String sql = "select clgid,company.compid,company.compname,jobs.jobid,jobtitle,jobs.walkindate, count(*) as cnt from jobs,company,job_applied,college where company.compid=jobs.compid and  jobs.jobid=job_applied.jobid and job_applied.result='pass'  and college.clgid='"+session.getAttribute("username")+ "' group by jobs.jobid having count(*) > 0"  ;
                //out.println(sql);
                ResultSet rs = st.executeQuery(sql);
%>


<table width="100%" border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td align="left" valign="top">

            <span class='messagesred' style="text-align:center">
            </span>

            <table width="100%" border="0" cellspacing="0" >
                <tr>
                    <td width="100%" align="left" valign="top"><span class="mainheading_emp" style="margin-bottom:10px;">Result of Companies</span></td>
              </tr>
                <tr>
                    <td height="10" align="left" valign="top" class="normal"></td>
                </tr>
                <tr>
                    <td height="26" align="left" valign="top" class="normal">
                        <table width="100%" border="0" cellspacing="2"  class="tbl_bdr">
                            <tr class="sde_mnu_hdr_blue">
                                <td width="24" align="left" valign="middle"><img style="margin-top:-5px; margin-left:-5px;" src="../images/top_left.gif";/></td>
                              <td colspan="7" align="right"> <a href="allresult.jsp" title="View Result"><input id="submit" name="submit" type="submit" value="View All Result" class="button2" style="width:130px; height:40px;"></a></td>
                            </tr>
                            <tr align="center" style="color:#000066;font-weight:bold">
                                <td height="34" ></td>
                              <td style="background-color: skyblue" width="30">#</td>
                              <td width="84"  valign="middle" class="subjeading" style="background-color: skyblue">Logo</td>
                              <td width="144"  valign="middle" class="subjeading" style="background-color: skyblue"> Company</td>
                              <td width="153"  valign="middle" class="subjeading" style="background-color: skyblue">Job Title</td>
                              <td width="139"  valign="middle" class="subjeading" style="background-color: skyblue">Walkindate</td>
                              <td width="152"  valign="middle" class="subjeading" style="background-color: skyblue">No. of Selected Student</td>


                              <td width="196"  valign="middle" class="subjeading" style="background-color: skyblue">Action</td>
                          </tr>

                            <%
                                int i=0;
                                while (rs.next()) { i++;
                            %>
                            <tr  valign="middle" style="font-weight:bold;text-align:center" >
                                <td height="94">&nbsp;</td>
                              <td align="center" width="30"><%=i%></td>
                              <td><img src="../src/getpic.jsp?id=<%=rs.getString("company.compid")%>&table=company&col=logo&pk_col=compid" width="83" height="51"></td>
                              <td ><%= rs.getString("company.compname")%></td>
                                <td ><%=rs.getString("jobs.jobtitle")%></td>
                                <td ><%=rs.getString("jobs.walkindate")%></td>
                                <td><%= rs.getString("cnt")%>          </td>

                                <td>

                                    <a href="result.jsp?jobid=<%=rs.getString("jobs.jobid")%>" title="View Result"><input id="submit" name="submit" type="submit" value="View Result" class="button2" style="width:100px; height:40px;"></a>
                                </td>
                            </tr>
                            <%}%>
							<tr align="center" >
                                <td height="31" ></td>
                              <td style="background-color: skyblue" width="30">&nbsp;</td>
                              <td width="84" align="left" valign="middle" class="subjeading" style="background-color: skyblue"></td>
                              <td width="144" align="left" valign="middle" class="subjeading" style="background-color: skyblue"></td>
                              <td width="153" align="left" valign="middle" class="subjeading" style="background-color: skyblue"></td>
                              <td width="139" align="left" valign="middle" class="subjeading" style="background-color: skyblue"></td>
                              <td width="152" align="left" valign="middle" class="subjeading" style="background-color: skyblue"></td>


                              <td width="196" align="left" valign="middle" class="subjeading" style="background-color: skyblue"></td>
                          </tr>
                        </table></td>
                </tr>
            </table></td>
    </tr>
</table>
<%} catch (Exception e) {
                out.println("<font color=\"black\">" + e + "</font>");
            }%>
<a href="http://apycom.com/"></a>